﻿CREATE PROCEDURE [dbo].[Address_Select]
@AddressID uniqueidentifier
AS
BEGIN

SELECT [AddressID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [ProvinceID]
, [Line1]
, [Line2]
, [Suburb]
, [Code]
, [Longitude]
, [Latitude]
FROM [dbo].[Address] (NoLock)
WHERE [Deleted] = 0
AND [AddressID] = @AddressID


END
